Change Measure Calculations

Visualizer provides a calculation of the measures across its attributes. By default, the calculation is the absolute value of the measure value.

Example: In BQLClosed Business Query Language, this is expressed as ABS([measure]) or ABS([OrderDate: Sum: Quantity]).

In some cases, you may want to use a different calculation in your chart. In addition to absolute value, you can apply a percentage across, in which each column or row is a percentage of the total.

You can access the BQL in the Expression Editor to customize the calculation.

Topics on This Page

Use a Percentage Across Calculation

Examples of Percentage Across Calculations

View and Edit a Calculation for a Custom Expression in Expression Builder

Use a Percentage Across Calculation

  1. Add a measure to Chart Builder and select it.

    Visualizer displays the options available for the measure.

  2. Select Calculation to see a list of possible calculations.

    Tip: If you do not see the Percentage Across calculation, then the attribute may be missing. Add an attribute to the chart.
  3. Click Percentage Across to see a list of relevant attributes.

  4. Click the attribute. Visualizer applies the calculation and does the following:
    • Updates the item in Chart Builder to show that it is a percentage across calculation;

    • Adds the new measure to the subject area list of measures;

      Tip: Click + on a calculated measure to delete it.
    • Updates the measure axis to show percentages.

Examples of Percentage Across Calculations

Example: This is a chart using the percentage across calculation. You can format the chart and tooltips to display the percentage values in different ways.

Example: This is the same information in table format, using a different decimal precision (the brackets indicate an expression is being used).

View and Edit a Calculation for a Custom Expression in Expression Builder

  1. Select a custom measure in Chart Builder.
  2. Click Edit to open the Expression Builder. The Expression Builder shows the BQL used for the calculation.

    Note: If you do not see the Edit option, then the measure is not a custom expression.
  3. Copy and/or edit the BQLClosed Business Query Language.
    Example: ([Inventory_Date: Sum: Current_Inventory]/[Inventory_Date: Sum: Current_Inventory]{[Products.Total]}) * 100
  4. Click Done.